Q3 — Software Engineering

Q3

#0000081409

3 / 48

The cells in a spreadsheet application are defined as follows.

Cells of a spreadsheet showing rows 1 through 4 and columns A through D. Cells are labeled as follows. Cell A 1 is 3. Cell B 1 is 12. Cell C 1 is equals sum C 2 through D 4. Cell D 1 is 7. Cell A 2 is 5. Cell B 2 is equals average C 2 through D 4. Cell C 1 is negative 1. Cell D 2 is equals C 3 times 2. Cell A 3 is equals D 2 to the second power. Cell B 3 is equals C 1 minus B 2. Cell C 3 is equals A 1 plus B 4. Cell D 3 is negative 10. Cell A 4 is absolute value B 3. Cell B 4 is negativee 4. Cell C 4 is 8. Cell D 4 is equals minimum A 1 to A 3.

What is the value of cell A4?